@echo off
echo 正在初始化MySQL表...

REM 执行创建数据库的SQL
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/00-create-databases.sql"

REM 执行创建用户表的SQL
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/01-schema.sql"
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/02-data.sql"
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/03-check.sql"

REM 执行创建音乐表的SQL
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/04-music-schema.sql"
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/05-check-music-tables.sql"
docker exec musicdreamer_mysql mysql -uroot -proot -e "source /docker-entrypoint-initdb.d/06-sample-music-data.sql"

echo 初始化完成! 